

--Report tables

-- Table: repsections

-- DROP TABLE repsections;

CREATE TABLE repsections
(
  id integer NOT NULL DEFAULT nextval('"repsections_ID_seq"'::regclass),
  sectionsql text,
  "header" character varying(100),
  sectiontype character varying(40),
  reportid integer,
  CONSTRAINT repsections_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE repsections OWNER TO speedtestadmin;



-- Table: reports

-- DROP TABLE reports;

CREATE TABLE reports
(
  id serial NOT NULL,
  reportname character varying(40),
  categoryid integer,
  "header" character varying(100),
  CONSTRAINT reports_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE reports OWNER TO speedtestadmin;


-- Table: repcategories

-- DROP TABLE repcategories;

CREATE TABLE repcategories
(
  id integer NOT NULL DEFAULT nextval('reportcategories_id_seq'::regclass),
  description character varying(40),
  CONSTRAINT reportcategories_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE repcategories OWNER TO speedtestadmin;
